package com.alks.function.mapper.procurement;

import com.alks.entity.data.entity.PurCompany;
import com.alks.entity.data.entity.PurCompany2;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.mapstruct.Mapper;

@Mapper
public interface PurCompanyMapper2 extends BaseMapper<PurCompany2> {

    @Select("select COMPANY_ID,ABBR_NAME,CHI_NAME,ENG_NAME,CHI_ADDR,ENG_ADDR,TELPHONE,FAX_NO,WEB_ADDR,EMAIL,POST_CODE,DELIVERY_ADDR,TITLE_NAME,SIGNATORY_NAME,SIGNATORY_ADDR,SIGNATORY_ENGADDR,SHORT_NAME,CONTACTS from PUR_COMPANY2 where COMPANY_ID = #{companyId} AND TYPE = #{type}")
    PurCompany2 findPurCompanyInfo(@Param("companyId") String companyId, @Param("type") String type);
}
